package com.mapper;

import com.model.Item;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface ItemMapper {
    @Select("select * from item")
    public List<Item> getItemList();

    @Select("select * from item where itemname=#{itemname}")
    public List<Item> getItemByName(@Param("itemname") String ItemName);

    @Select("select * from item where id=#{id}")
    public Item getItemById(@Param("id") Long Id);
}
